Tabela MedResource

Definicja tabeli MedResource

Name

MedResource

Code

MedResource

Comment

PL: Lista zasobów medycznych (lekarzy i urzadzen)
EN: Medical resources list (persons and equipment)
DE: Die Tabelle fur den ärztlichen Ausweg


Lista kolumn tabeli MedResource

Name

Code

MedResourceID

MedResourceID

PersonID

PersonID

EquipmentID

EquipmentID

NotForEregistration

NotForEregistration


Kolumna MedResourceID tabeli MedResource

Definicja kolumny MedResourceID tabeli MedResource

Name

MedResourceID

Code

MedResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli MedResource

Definicja kolumny PersonID tabeli MedResource

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EquipmentID tabeli MedResource

Definicja kolumny EquipmentID tabeli MedResource

Name

EquipmentID

Code

EquipmentID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NotForEregistration tabeli MedResource

Definicja kolumny NotForEregistration tabeli MedResource

Name

NotForEregistration

Code

NotForEregistration

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Informacja czy dany lekarz jest niedostepny z poziomu e-rejestracji, 0-dostepny 1-niedostepny.


Lista kluczy tabeli MedResource

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MedResource

Definicja klucza Identifier_1 tabeli MedResource

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment